Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_TEMP_FILES

`DBA_TEMP_FILES` describes all temporary files (tempfiles) in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`FILE_NAME` | `VARCHAR2(513)` |  | Name of the database temp file
`FILE_ID` | `NUMBER` |  | File identifier number of the database temp file
`TABLESPACE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the tablespace to which the file belongs
`BYTES` | `NUMBER` |  | Size of the file (in bytes)
`BLOCKS` | `NUMBER` |  | Size of the file (in Oracle blocks)
`STATUS` | `CHAR(9)` |  | File status: `AVAILABLE`
`RELATIVE_FNO` | `NUMBER` |  | Tablespace-relative file number
`AUTOEXTENSIBLE` | `VARCHAR2(3)` |  | Indicates whether the file is autoextensible (`YES`) or not (`NO`)
`MAXBYTES` | `NUMBER` |  | maximum size of the file (in bytes)
`MAXBLOCKS` | `NUMBER` |  | Maximum size of the file (in Oracle blocks)
`INCREMENT_BY` | `NUMBER` |  | Default increment for autoextension
`USER_BYTES` | `NUMBER` |  | Size of the useful portion of the file (in bytes)
`USER_BLOCKS` | `NUMBER` |  | Size of the useful portion of the file (in Oracle blocks)